Identifier labels
Last updated: 3/10/2026Several statements are tagged with an identifier label for troubleshooting 'problem queries' and identifying possible ways to optimize database settings. The addition of labels to ELT queries enables fine-grained workload management and workload isolation via Synapse WORKLOAD GROUPS and CLASSIFIERS.
The identifier labels are as follows:
| Table type | Tag |
|---|---|
| Hubs |
CMPS_HubIns |
| Satellites | CMPS_SatIns |
| Type1 dimensions | CMPS_<data mart name>_DimT1_Init/CMPS_<data mart name>_DimT1_Incr |
| Type2 dimensions | CMPS_<data mart name>_DimT2_Init/CMPS_<data mart name>_DimT2_Incr |
| Transactional facts | CMPS_<data mart name>_FctTra_Init/CMPS_<data mart name>_FctTra_Incr |
| State-oriented facts | CMPS_<data mart name>_FctStO_Init |
| Aggregated facts | CMPS_<data mart name>_FctAgg_Init |